Overview

Dataset statistics

Number of variables19
Number of observations18287
Missing cells83301
Missing cells (%)24.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 MiB
Average record size in memory152.0 B

Variable types

Numeric8
Categorical7
DateTime1
Unsupported3

Alerts

linqmap_reportMood has constant value "0" Constant
nComments has constant value "0" Constant
linqmap_city has a high cardinality: 77 distinct values High cardinality
linqmap_street has a high cardinality: 1208 distinct values High cardinality
linqmap_roadType is highly correlated with linqmap_reportRatingHigh correlation
linqmap_reportRating is highly correlated with linqmap_roadType and 1 other fieldsHigh correlation
linqmap_magvar is highly correlated with linqmap_reportRatingHigh correlation
linqmap_reportRating is highly correlated with linqmap_magvarHigh correlation
linqmap_magvar is highly correlated with linqmap_reportRatingHigh correlation
OBJECTID is highly correlated with update_dateHigh correlation
linqmap_reportRating is highly correlated with linqmap_magvarHigh correlation
linqmap_magvar is highly correlated with linqmap_reportRatingHigh correlation
update_date is highly correlated with OBJECTIDHigh correlation
linqmap_city is highly correlated with linqmap_reportDescription and 2 other fieldsHigh correlation
linqmap_reportDescription is highly correlated with linqmap_city and 4 other fieldsHigh correlation
linqmap_type is highly correlated with linqmap_reportDescription and 3 other fieldsHigh correlation
nComments is highly correlated with linqmap_city and 4 other fieldsHigh correlation
linqmap_subtype is highly correlated with linqmap_reportDescription and 3 other fieldsHigh correlation
linqmap_reportMood is highly correlated with linqmap_city and 4 other fieldsHigh correlation
OBJECTID is highly correlated with update_dateHigh correlation
linqmap_type is highly correlated with linqmap_subtype and 4 other fieldsHigh correlation
linqmap_subtype is highly correlated with linqmap_type and 5 other fieldsHigh correlation
linqmap_reportDescription is highly correlated with linqmap_magvarHigh correlation
linqmap_city is highly correlated with linqmap_type and 7 other fieldsHigh correlation
linqmap_roadType is highly correlated with linqmap_subtype and 1 other fieldsHigh correlation
linqmap_reportRating is highly correlated with linqmap_type and 4 other fieldsHigh correlation
linqmap_magvar is highly correlated with linqmap_type and 4 other fieldsHigh correlation
linqmap_reliability is highly correlated with linqmap_type and 3 other fieldsHigh correlation
update_date is highly correlated with OBJECTIDHigh correlation
x is highly correlated with linqmap_city and 1 other fieldsHigh correlation
y is highly correlated with linqmap_city and 1 other fieldsHigh correlation
linqmap_subtype has 907 (5.0%) missing values Missing
linqmap_reportDescription has 17949 (98.2%) missing values Missing
linqmap_city has 7850 (42.9%) missing values Missing
linqmap_street has 1734 (9.5%) missing values Missing
linqmap_nearby has 18287 (100.0%) missing values Missing
linqmap_expectedBeginDate has 18287 (100.0%) missing values Missing
linqmap_expectedEndDate has 18287 (100.0%) missing values Missing
linqmap_nearby is an unsupported type, check if it needs cleaning or further analysis Unsupported
linqmap_expectedBeginDate is an unsupported type, check if it needs cleaning or further analysis Unsupported
linqmap_expectedEndDate is an unsupported type, check if it needs cleaning or further analysis Unsupported
linqmap_roadType has 333 (1.8%) zeros Zeros
linqmap_reportRating has 7011 (38.3%) zeros Zeros
linqmap_magvar has 7086 (38.7%) zeros Zeros

Reproduction

Analysis started2022-06-02 08:41:46.363205
Analysis finished2022-06-02 08:41:58.704680
Duration12.34 seconds
Software versionpandas-profiling v3.2.0
Download configurationconfig.json

Variables

OBJECTID
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct17133
Distinct (%)93.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean116434.9893
Minimum12568
Maximum187271
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum12568
5-th percentile16550.3
Q137431.5
median142508
Q3170041.5
95-th percentile181005.7
Maximum187271
Range174703
Interquartile range (IQR)132610

Descriptive statistics

Standard deviation63082.72992
Coefficient of variation (CV)0.5417849935
Kurtosis-1.272363107
Mean116434.9893
Median Absolute Deviation (MAD)32004
Skewness-0.6477076819
Sum2129246649
Variance3979430814
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1744494
 
< 0.1%
1744754
 
< 0.1%
1744734
 
< 0.1%
1744724
 
< 0.1%
1744714
 
< 0.1%
1744704
 
< 0.1%
1744694
 
< 0.1%
1744684
 
< 0.1%
1744674
 
< 0.1%
1744664
 
< 0.1%
Other values (17123)18247
99.8%
ValueCountFrequency (%)
125681
< 0.1%
125691
< 0.1%
125701
< 0.1%
125711
< 0.1%
125721
< 0.1%
125731
< 0.1%
125741
< 0.1%
125751
< 0.1%
125761
< 0.1%
125771
< 0.1%
ValueCountFrequency (%)
1872711
< 0.1%
1872701
< 0.1%
1872691
< 0.1%
1872681
< 0.1%
1872671
< 0.1%
1872661
< 0.1%
1872651
< 0.1%
1872641
< 0.1%
1872631
< 0.1%
1872621
< 0.1%

linqmap_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size143.0 KiB
JAM
8387 
ROAD_CLOSED
6685 
WEATHERHAZARD
3023 
ACCIDENT
 
192

Length

Max length13
Median length11
Mean length7.630065074
Min length3

Characters and Unicode

Total characters139531
Distinct characters17
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowJAM
2nd rowWEATHERHAZARD
3rd rowJAM
4th rowACCIDENT
5th rowJAM

Common Values

ValueCountFrequency (%)
JAM8387
45.9%
ROAD_CLOSED6685
36.6%
WEATHERHAZARD3023
 
16.5%
ACCIDENT192
 
1.0%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
jam8387
45.9%
road_closed6685
36.6%
weatherhazard3023
 
16.5%
accident192
 
1.0%

Most occurring characters

ValueCountFrequency (%)
A24333
17.4%
D16585
11.9%
O13370
9.6%
E12923
9.3%
R12731
9.1%
J8387
 
6.0%
M8387
 
6.0%
C7069
 
5.1%
S6685
 
4.8%
L6685
 
4.8%
Other values (7)22376
16.0%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter132846
95.2%
Connector Punctuation6685
 
4.8%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A24333
18.3%
D16585
12.5%
O13370
10.1%
E12923
9.7%
R12731
9.6%
J8387
 
6.3%
M8387
 
6.3%
C7069
 
5.3%
S6685
 
5.0%
L6685
 
5.0%
Other values (6)15691
11.8%
Connector Punctuation
ValueCountFrequency (%)
_6685
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin132846
95.2%
Common6685
 
4.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
A24333
18.3%
D16585
12.5%
O13370
10.1%
E12923
9.7%
R12731
9.6%
J8387
 
6.3%
M8387
 
6.3%
C7069
 
5.3%
S6685
 
5.0%
L6685
 
5.0%
Other values (6)15691
11.8%
Common
ValueCountFrequency (%)
_6685
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII139531
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A24333
17.4%
D16585
11.9%
O13370
9.6%
E12923
9.3%
R12731
9.1%
J8387
 
6.0%
M8387
 
6.0%
C7069
 
5.1%
S6685
 
4.8%
L6685
 
4.8%
Other values (7)22376
16.0%

linqmap_subtype
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct24
Distinct (%)0.1%
Missing907
Missing (%)5.0%
Memory size143.0 KiB
ROAD_CLOSED_EVENT
6630 
JAM_STAND_STILL_TRAFFIC
4429 
JAM_HEAVY_TRAFFIC
2285 
HAZARD_ON_SHOULDER_CAR_STOPPED
1641 
JAM_MODERATE_TRAFFIC
1100 
Other values (19)
1295 

Length

Max length34
Median length17
Mean length20.51973533
Min length14

Characters and Unicode

Total characters356633
Distinct characters25
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st rowJAM_STAND_STILL_TRAFFIC
2nd rowHAZARD_ON_SHOULDER_CAR_STOPPED
3rd rowJAM_STAND_STILL_TRAFFIC
4th rowJAM_STAND_STILL_TRAFFIC
5th rowJAM_STAND_STILL_TRAFFIC

Common Values

ValueCountFrequency (%)
ROAD_CLOSED_EVENT6630
36.3%
JAM_STAND_STILL_TRAFFIC4429
24.2%
JAM_HEAVY_TRAFFIC2285
 
12.5%
HAZARD_ON_SHOULDER_CAR_STOPPED1641
 
9.0%
JAM_MODERATE_TRAFFIC1100
 
6.0%
HAZARD_ON_ROAD_CONSTRUCTION605
 
3.3%
HAZARD_ON_ROAD_CAR_STOPPED329
 
1.8%
HAZARD_WEATHER_FOG100
 
0.5%
ACCIDENT_MINOR48
 
0.3%
ROAD_CLOSED_CONSTRUCTION40
 
0.2%
Other values (14)173
 
0.9%
(Missing)907
 
5.0%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
road_closed_event6630
38.1%
jam_stand_still_traffic4429
25.5%
jam_heavy_traffic2285
 
13.1%
hazard_on_shoulder_car_stopped1641
 
9.4%
jam_moderate_traffic1100
 
6.3%
hazard_on_road_construction605
 
3.5%
hazard_on_road_car_stopped329
 
1.9%
hazard_weather_fog100
 
0.6%
accident_minor48
 
0.3%
road_closed_construction40
 
0.2%
Other values (14)173
 
1.0%

Most occurring characters

ValueCountFrequency (%)
_43833
12.3%
A39018
10.9%
E28426
 
8.0%
T27968
 
7.8%
D26446
 
7.4%
R23927
 
6.7%
O23403
 
6.6%
S19852
 
5.6%
C17966
 
5.0%
L17277
 
4.8%
Other values (15)88517
24.8%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter312800
87.7%
Connector Punctuation43833
 
12.3%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A39018
12.5%
E28426
 
9.1%
T27968
 
8.9%
D26446
 
8.5%
R23927
 
7.6%
O23403
 
7.5%
S19852
 
6.3%
C17966
 
5.7%
L17277
 
5.5%
F15775
 
5.0%
Other values (14)72742
23.3%
Connector Punctuation
ValueCountFrequency (%)
_43833
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin312800
87.7%
Common43833
 
12.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
A39018
12.5%
E28426
 
9.1%
T27968
 
8.9%
D26446
 
8.5%
R23927
 
7.6%
O23403
 
7.5%
S19852
 
6.3%
C17966
 
5.7%
L17277
 
5.5%
F15775
 
5.0%
Other values (14)72742
23.3%
Common
ValueCountFrequency (%)
_43833
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII356633
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_43833
12.3%
A39018
10.9%
E28426
 
8.0%
T27968
 
7.8%
D26446
 
7.4%
R23927
 
6.7%
O23403
 
6.6%
S19852
 
5.6%
C17966
 
5.0%
L17277
 
4.8%
Other values (15)88517
24.8%
Distinct9989
Distinct (%)54.6%
Missing0
Missing (%)0.0%
Memory size143.0 KiB
Minimum2021-02-07 03:00:00
Maximum2022-05-24 12:51:44
Histogram with fixed size bins (bins=50)

linqmap_reportDescription
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct3
Distinct (%)0.9%
Missing17949
Missing (%)98.2%
Memory size143.0 KiB
חסר מידע
296 
אתר התארגנות - הקו הירוק של הרכבת הקלה
37 
עבודות-סגירה חלקית
 
5

Length

Max length38
Median length8
Mean length11.43195266
Min length8

Characters and Unicode

Total characters3864
Distinct characters20
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowאתר התארגנות - הקו הירוק של הרכבת הקלה
2nd rowחסר מידע
3rd rowחסר מידע
4th rowחסר מידע
5th rowחסר מידע

Common Values

ValueCountFrequency (%)
חסר מידע296
 
1.6%
אתר התארגנות - הקו הירוק של הרכבת הקלה37
 
0.2%
עבודות-סגירה חלקית5
 
< 0.1%
(Missing)17949
98.2%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
חסר296
33.0%
מידע296
33.0%
אתר37
 
4.1%
התארגנות37
 
4.1%
37
 
4.1%
הקו37
 
4.1%
הירוק37
 
4.1%
של37
 
4.1%
הרכבת37
 
4.1%
הקלה37
 
4.1%
Other values (2)10
 
1.1%

Most occurring characters

ValueCountFrequency (%)
560
14.5%
ר449
11.6%
י343
8.9%
ח301
7.8%
ס301
7.8%
ד301
7.8%
ע301
7.8%
מ296
7.7%
ה227
 
5.9%
ת158
 
4.1%
Other values (10)627
16.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter3262
84.4%
Space Separator560
 
14.5%
Dash Punctuation42
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
ר449
13.8%
י343
10.5%
ח301
9.2%
ס301
9.2%
ד301
9.2%
ע301
9.2%
מ296
9.1%
ה227
7.0%
ת158
 
4.8%
ו121
 
3.7%
Other values (8)464
14.2%
Space Separator
ValueCountFrequency (%)
560
100.0%
Dash Punctuation
ValueCountFrequency (%)
-42
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hebrew3262
84.4%
Common602
 
15.6%

Most frequent character per script

Hebrew
ValueCountFrequency (%)
ר449
13.8%
י343
10.5%
ח301
9.2%
ס301
9.2%
ד301
9.2%
ע301
9.2%
מ296
9.1%
ה227
7.0%
ת158
 
4.8%
ו121
 
3.7%
Other values (8)464
14.2%
Common
ValueCountFrequency (%)
560
93.0%
-42
 
7.0%

Most occurring blocks

ValueCountFrequency (%)
Hebrew3262
84.4%
ASCII602
 
15.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
560
93.0%
-42
 
7.0%
Hebrew
ValueCountFrequency (%)
ר449
13.8%
י343
10.5%
ח301
9.2%
ס301
9.2%
ד301
9.2%
ע301
9.2%
מ296
9.1%
ה227
7.0%
ת158
 
4.8%
ו121
 
3.7%
Other values (8)464
14.2%

linqmap_city
Categorical

HIGH CARDINALITY
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct77
Distinct (%)0.7%
Missing7850
Missing (%)42.9%
Memory size143.0 KiB
תל אביב - יפו
4502 
אור יהודה
950 
חולון
527 
רמת גן
501 
פתח תקווה
 
445
Other values (72)
3512 

Length

Max length23
Median length19
Mean length10.025103
Min length3

Characters and Unicode

Total characters104632
Distinct characters38
Distinct categories6 ?
Distinct scripts4 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16 ?
Unique (%)0.2%

Sample

1st rowפלמחים
2nd rowפתח תקווה
3rd rowגבעתיים
4th rowרמת גן
5th rowיהוד-מונוסון

Common Values

ValueCountFrequency (%)
תל אביב - יפו4502
24.6%
אור יהודה950
 
5.2%
חולון527
 
2.9%
רמת גן501
 
2.7%
פתח תקווה445
 
2.4%
יהוד-מונוסון376
 
2.1%
ראשון לציון351
 
1.9%
בני ברק330
 
1.8%
רחובות311
 
1.7%
בת ים284
 
1.6%
Other values (67)1860
 
10.2%
(Missing)7850
42.9%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
תל4507
16.2%
4504
16.2%
יפו4502
16.2%
אביב4502
16.2%
יהודה959
 
3.5%
אור950
 
3.4%
רמת711
 
2.6%
חולון527
 
1.9%
גן505
 
1.8%
תקווה449
 
1.6%
Other values (101)5656
20.4%

Most occurring characters

ValueCountFrequency (%)
17335
16.6%
י12564
12.0%
ו12348
11.8%
ב10915
10.4%
ת7386
7.1%
א6488
 
6.2%
ל5758
 
5.5%
פ5248
 
5.0%
-4988
 
4.8%
ה3945
 
3.8%
Other values (28)17657
16.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter82291
78.6%
Space Separator17335
 
16.6%
Dash Punctuation4988
 
4.8%
Lowercase Letter14
 
< 0.1%
Uppercase Letter2
 
< 0.1%
Other Punctuation2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
י12564
15.3%
ו12348
15.0%
ב10915
13.3%
ת7386
9.0%
א6488
7.9%
ל5758
7.0%
פ5248
6.4%
ה3945
 
4.8%
ר3765
 
4.6%
ן2587
 
3.1%
Other values (19)11287
13.7%
Lowercase Letter
ValueCountFrequency (%)
a4
28.6%
l4
28.6%
i2
14.3%
y2
14.3%
q2
14.3%
Space Separator
ValueCountFrequency (%)
17335
100.0%
Dash Punctuation
ValueCountFrequency (%)
-4988
100.0%
Uppercase Letter
ValueCountFrequency (%)
Q2
100.0%
Other Punctuation
ValueCountFrequency (%)
"2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hebrew82277
78.6%
Common22325
 
21.3%
Latin16
 
< 0.1%
Arabic14
 
< 0.1%

Most frequent character per script

Hebrew
ValueCountFrequency (%)
י12564
15.3%
ו12348
15.0%
ב10915
13.3%
ת7386
9.0%
א6488
7.9%
ל5758
7.0%
פ5248
6.4%
ה3945
 
4.8%
ר3765
 
4.6%
ן2587
 
3.1%
Other values (15)11273
13.7%
Latin
ValueCountFrequency (%)
a4
25.0%
l4
25.0%
i2
12.5%
y2
12.5%
q2
12.5%
Q2
12.5%
Arabic
ValueCountFrequency (%)
ق4
28.6%
ي4
28.6%
ل4
28.6%
ة2
14.3%
Common
ValueCountFrequency (%)
17335
77.6%
-4988
 
22.3%
"2
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hebrew82277
78.6%
ASCII22341
 
21.4%
Arabic14
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
17335
77.6%
-4988
 
22.3%
a4
 
< 0.1%
l4
 
< 0.1%
i2
 
< 0.1%
y2
 
< 0.1%
q2
 
< 0.1%
Q2
 
< 0.1%
"2
 
< 0.1%
Hebrew
ValueCountFrequency (%)
י12564
15.3%
ו12348
15.0%
ב10915
13.3%
ת7386
9.0%
א6488
7.9%
ל5758
7.0%
פ5248
6.4%
ה3945
 
4.8%
ר3765
 
4.6%
ן2587
 
3.1%
Other values (15)11273
13.7%
Arabic
ValueCountFrequency (%)
ق4
28.6%
ي4
28.6%
ل4
28.6%
ة2
14.3%

linqmap_street
Categorical

HIGH CARDINALITY
MISSING

Distinct1208
Distinct (%)7.3%
Missing1734
Missing (%)9.5%
Memory size143.0 KiB
שד ירושלים
 
911
6 דרום
 
617
4 דרום
 
510
4 צפון
 
464
בן יהודה
 
403
Other values (1203)
13648 

Length

Max length47
Median length37
Mean length8.545037153
Min length1

Characters and Unicode

Total characters141446
Distinct characters46
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique426 ?
Unique (%)2.6%

Sample

1st row443 מערב
2nd rowל-6 דרום
3rd rowבן גוריון
4th row44 צפון
5th row2 דרום

Common Values

ValueCountFrequency (%)
שד ירושלים911
 
5.0%
6 דרום617
 
3.4%
4 דרום510
 
2.8%
4 צפון464
 
2.5%
בן יהודה403
 
2.2%
יגאל אלון382
 
2.1%
שתולים326
 
1.8%
6 צפון300
 
1.6%
20 איילון דרום283
 
1.5%
ארלוזורוב276
 
1.5%
Other values (1198)12081
66.1%
(Missing)1734
 
9.5%

Length

Histogram of lengths of the category
ValueCountFrequency (%)
דרום2211
 
6.9%
צפון1684
 
5.2%
שד1299
 
4.0%
ירושלים1115
 
3.5%
4998
 
3.1%
6990
 
3.1%
מערב930
 
2.9%
מזרח786
 
2.4%
בן784
 
2.4%
איילון727
 
2.3%
Other values (1116)20616
64.1%

Most occurring characters

ValueCountFrequency (%)
15587
 
11.0%
ו13777
 
9.7%
י12946
 
9.2%
ר10671
 
7.5%
ל8732
 
6.2%
ד6566
 
4.6%
ן5816
 
4.1%
ה5500
 
3.9%
ב5117
 
3.6%
ש4952
 
3.5%
Other values (36)51782
36.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter110882
78.4%
Space Separator15587
 
11.0%
Decimal Number11895
 
8.4%
Dash Punctuation1612
 
1.1%
Other Punctuation1050
 
0.7%
Open Punctuation210
 
0.1%
Close Punctuation210
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
ו13777
12.4%
י12946
11.7%
ר10671
 
9.6%
ל8732
 
7.9%
ד6566
 
5.9%
ן5816
 
5.2%
ה5500
 
5.0%
ב5117
 
4.6%
ש4952
 
4.5%
א4850
 
4.4%
Other values (17)31955
28.8%
Decimal Number
ValueCountFrequency (%)
43923
33.0%
11669
14.0%
21484
 
12.5%
61284
 
10.8%
01245
 
10.5%
51046
 
8.8%
3724
 
6.1%
7421
 
3.5%
892
 
0.8%
97
 
0.1%
Other Punctuation
ValueCountFrequency (%)
,752
71.6%
"220
 
21.0%
/48
 
4.6%
.19
 
1.8%
׳11
 
1.0%
Space Separator
ValueCountFrequency (%)
15587
100.0%
Dash Punctuation
ValueCountFrequency (%)
-1612
100.0%
Open Punctuation
ValueCountFrequency (%)
(210
100.0%
Close Punctuation
ValueCountFrequency (%)
)210
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hebrew110893
78.4%
Common30553
 
21.6%

Most frequent character per script

Hebrew
ValueCountFrequency (%)
ו13777
12.4%
י12946
11.7%
ר10671
 
9.6%
ל8732
 
7.9%
ד6566
 
5.9%
ן5816
 
5.2%
ה5500
 
5.0%
ב5117
 
4.6%
ש4952
 
4.5%
א4850
 
4.4%
Other values (18)31966
28.8%
Common
ValueCountFrequency (%)
15587
51.0%
43923
 
12.8%
11669
 
5.5%
-1612
 
5.3%
21484
 
4.9%
61284
 
4.2%
01245
 
4.1%
51046
 
3.4%
,752
 
2.5%
3724
 
2.4%
Other values (8)1227
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hebrew110893
78.4%
ASCII30553
 
21.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
15587
51.0%
43923
 
12.8%
11669
 
5.5%
-1612
 
5.3%
21484
 
4.9%
61284
 
4.2%
01245
 
4.1%
51046
 
3.4%
,752
 
2.5%
3724
 
2.4%
Other values (8)1227
 
4.0%
Hebrew
ValueCountFrequency (%)
ו13777
12.4%
י12946
11.7%
ר10671
 
9.6%
ל8732
 
7.9%
ד6566
 
5.9%
ן5816
 
5.2%
ה5500
 
5.0%
ב5117
 
4.6%
ש4952
 
4.5%
א4850
 
4.4%
Other values (18)31966
28.8%

linqmap_nearby
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing18287
Missing (%)100.0%
Memory size143.0 KiB

linqmap_roadType
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct13
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.976540712
Minimum0
Maximum22
Zeros333
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median2
Q33
95-th percentile6
Maximum22
Range22
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.630400269
Coefficient of variation (CV)0.8837104961
Kurtosis18.2604061
Mean2.976540712
Median Absolute Deviation (MAD)1
Skewness3.733319605
Sum54432
Variance6.919005576
MonotonicityNot monotonic
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
26767
37.0%
33783
20.7%
13239
17.7%
41725
 
9.4%
61613
 
8.8%
7451
 
2.5%
0333
 
1.8%
17235
 
1.3%
2095
 
0.5%
1637
 
0.2%
Other values (3)9
 
< 0.1%
ValueCountFrequency (%)
0333
 
1.8%
13239
17.7%
26767
37.0%
33783
20.7%
41725
 
9.4%
61613
 
8.8%
7451
 
2.5%
87
 
< 0.1%
101
 
< 0.1%
1637
 
0.2%
ValueCountFrequency (%)
221
 
< 0.1%
2095
 
0.5%
17235
 
1.3%
1637
 
0.2%
101
 
< 0.1%
87
 
< 0.1%
7451
 
2.5%
61613
8.8%
41725
9.4%
33783
20.7%

linqmap_reportMood
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size143.0 KiB
0
18287 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters18287
Distinct characters1
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
018287
100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
018287
100.0%

Most occurring characters

ValueCountFrequency (%)
018287
100.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number18287
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
018287
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common18287
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
018287
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII18287
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
018287
100.0%

linqmap_reportRating
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.993656696
Minimum0
Maximum5
Zeros7011
Zeros (%)38.3%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median5
Q35
95-th percentile5
Maximum5
Range5
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.411659855
Coefficient of variation (CV)0.8055899858
Kurtosis-1.808449111
Mean2.993656696
Median Absolute Deviation (MAD)0
Skewness-0.4054205895
Sum54745
Variance5.816103258
MonotonicityNot monotonic
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
510558
57.7%
07011
38.3%
4251
 
1.4%
3178
 
1.0%
1161
 
0.9%
2128
 
0.7%
ValueCountFrequency (%)
07011
38.3%
1161
 
0.9%
2128
 
0.7%
3178
 
1.0%
4251
 
1.4%
510558
57.7%
ValueCountFrequency (%)
510558
57.7%
4251
 
1.4%
3178
 
1.0%
2128
 
0.7%
1161
 
0.9%
07011
38.3%

linqmap_expectedBeginDate
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing18287
Missing (%)100.0%
Memory size143.0 KiB

linqmap_expectedEndDate
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing18287
Missing (%)100.0%
Memory size143.0 KiB

linqmap_magvar
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct360
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean106.6642424
Minimum0
Maximum359
Zeros7086
Zeros (%)38.7%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median42
Q3201
95-th percentile327
Maximum359
Range359
Interquartile range (IQR)201

Descriptive statistics

Standard deviation118.5412674
Coefficient of variation (CV)1.11134964
Kurtosis-1.062369076
Mean106.6642424
Median Absolute Deviation (MAD)42
Skewness0.6341564302
Sum1950569
Variance14052.03207
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
07086
38.7%
359136
 
0.7%
9117
 
0.6%
8111
 
0.6%
192101
 
0.6%
190100
 
0.5%
19193
 
0.5%
20193
 
0.5%
20087
 
0.5%
19586
 
0.5%
Other values (350)10277
56.2%
ValueCountFrequency (%)
07086
38.7%
142
 
0.2%
252
 
0.3%
356
 
0.3%
449
 
0.3%
540
 
0.2%
669
 
0.4%
755
 
0.3%
8111
 
0.6%
9117
 
0.6%
ValueCountFrequency (%)
359136
0.7%
35847
 
0.3%
35748
 
0.3%
35633
 
0.2%
35544
 
0.2%
35451
 
0.3%
35327
 
0.1%
35232
 
0.2%
35150
 
0.3%
35032
 
0.2%

nComments
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size143.0 KiB
0
18287 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters18287
Distinct characters1
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0
2nd row0
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
018287
100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

ValueCountFrequency (%)
018287
100.0%

Most occurring characters

ValueCountFrequency (%)
018287
100.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number18287
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
018287
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common18287
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
018287
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII18287
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
018287
100.0%

linqmap_reliability
Real number (ℝ≥0)

HIGH CORRELATION

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.315579373
Minimum5
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum5
5-th percentile5
Q15
median6
Q310
95-th percentile10
Maximum10
Range5
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.094243913
Coefficient of variation (CV)0.2862717778
Kurtosis-1.646556163
Mean7.315579373
Median Absolute Deviation (MAD)1
Skewness0.2765046277
Sum133780
Variance4.385857565
MonotonicityNot monotonic
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
106007
32.8%
55095
27.9%
64224
23.1%
71392
 
7.6%
8974
 
5.3%
9595
 
3.3%
ValueCountFrequency (%)
55095
27.9%
64224
23.1%
71392
 
7.6%
8974
 
5.3%
9595
 
3.3%
106007
32.8%
ValueCountFrequency (%)
106007
32.8%
9595
 
3.3%
8974
 
5.3%
71392
 
7.6%
64224
23.1%
55095
27.9%

update_date
Real number (ℝ≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct5135
Distinct (%)28.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.652874385 × 1012
Minimum1.652608382 × 1012
Maximum1.653396783 × 1012
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum1.652608382 × 1012
5-th percentile1.652622782 × 1012
Q11.652781183 × 1012
median1.652813583 × 1012
Q31.652860383 × 1012
95-th percentile1.653389583 × 1012
Maximum1.653396783 × 1012
Range788400312
Interquartile range (IQR)79200108

Descriptive statistics

Standard deviation227760498.5
Coefficient of variation (CV)0.0001377966169
Kurtosis1.125945313
Mean1.652874385 × 1012
Median Absolute Deviation (MAD)32400100
Skewness1.523369388
Sum3.022611388 × 1016
Variance5.187484467 × 1016
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.652839383 × 101228
 
0.2%
1.652839383 × 101228
 
0.2%
1.652839383 × 101228
 
0.2%
1.652839383 × 101228
 
0.2%
1.652839383 × 101228
 
0.2%
1.652863983 × 101227
 
0.1%
1.652629982 × 101225
 
0.1%
1.652817182 × 101225
 
0.1%
1.652629982 × 101225
 
0.1%
1.652839384 × 101224
 
0.1%
Other values (5125)18021
98.5%
ValueCountFrequency (%)
1.652608382 × 10121
 
< 0.1%
1.652608382 × 10121
 
< 0.1%
1.652608382 × 10123
< 0.1%
1.652608382 × 10124
< 0.1%
1.652608382 × 10121
 
< 0.1%
1.652608382 × 10121
 
< 0.1%
1.652608382 × 10127
< 0.1%
1.652608382 × 10123
< 0.1%
1.652608382 × 10124
< 0.1%
1.652608382 × 10123
< 0.1%
ValueCountFrequency (%)
1.653396783 × 10126
< 0.1%
1.653396783 × 10123
< 0.1%
1.653396783 × 10123
< 0.1%
1.653396783 × 10126
< 0.1%
1.653396783 × 10127
< 0.1%
1.653396783 × 10123
< 0.1%
1.653396783 × 10123
< 0.1%
1.653396783 × 10123
< 0.1%
1.653396783 × 10126
< 0.1%
1.653396783 × 10124
< 0.1%

x
Real number (ℝ≥0)

HIGH CORRELATION

Distinct11272
Distinct (%)61.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean184336.3311
Minimum164717.1
Maximum201742.85
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum164717.1
5-th percentile177015.08
Q1179115.53
median183245.84
Q3187908.905
95-th percentile196673.437
Maximum201742.85
Range37025.75
Interquartile range (IQR)8793.375

Descriptive statistics

Standard deviation6507.341846
Coefficient of variation (CV)0.03530146123
Kurtosis0.03644758349
Mean184336.3311
Median Absolute Deviation (MAD)4246.8
Skewness0.561943231
Sum3370958487
Variance42345497.9
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
178825.86259
 
1.4%
186260.9279
 
0.4%
186255.7479
 
0.4%
178747.0475
 
0.4%
178578.9274
 
0.4%
188285.5974
 
0.4%
187667.6774
 
0.4%
178618.1874
 
0.4%
180770.374
 
0.4%
180759.6874
 
0.4%
Other values (11262)17351
94.9%
ValueCountFrequency (%)
164717.11
 
< 0.1%
165786.411
 
< 0.1%
165871.711
 
< 0.1%
166117.211
 
< 0.1%
166276.831
 
< 0.1%
166287.491
 
< 0.1%
166495.291
 
< 0.1%
166532.141
 
< 0.1%
166600.819
< 0.1%
166639.49
< 0.1%
ValueCountFrequency (%)
201742.855
< 0.1%
201712.181
 
< 0.1%
201708.61
 
< 0.1%
201682.371
 
< 0.1%
201680.231
 
< 0.1%
201671.461
 
< 0.1%
201669.391
 
< 0.1%
201664.881
 
< 0.1%
201662.391
 
< 0.1%
201661.351
 
< 0.1%

y
Real number (ℝ≥0)

HIGH CORRELATION

Distinct11286
Distinct (%)61.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean663304.8278
Minimum630669.73
Maximum696807.08
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size143.0 KiB

Quantile statistics

Minimum630669.73
5-th percentile643831.779
Q1658984.21
median663036.88
Q3667294.345
95-th percentile687481.238
Maximum696807.08
Range66137.35
Interquartile range (IQR)8310.135

Descriptive statistics

Standard deviation11515.93411
Coefficient of variation (CV)0.01736145077
Kurtosis1.274724882
Mean663304.8278
Median Absolute Deviation (MAD)4135.11
Skewness0.2063734448
Sum1.212985539 × 1010
Variance132616738.5
MonotonicityNot monotonic
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
665089.18259
 
1.4%
659751.1179
 
0.4%
659726.9679
 
0.4%
665885.8974
 
0.4%
659530.0674
 
0.4%
665686.4674
 
0.4%
659861.0174
 
0.4%
662145.5274
 
0.4%
661531.8774
 
0.4%
666085.1974
 
0.4%
Other values (11276)17352
94.9%
ValueCountFrequency (%)
630669.731
< 0.1%
630707.131
< 0.1%
630854.481
< 0.1%
630961.161
< 0.1%
631051.271
< 0.1%
631091.641
< 0.1%
631151.581
< 0.1%
631293.711
< 0.1%
631389.771
< 0.1%
631395.031
< 0.1%
ValueCountFrequency (%)
696807.081
< 0.1%
696805.161
< 0.1%
696800.441
< 0.1%
696745.111
< 0.1%
696685.141
< 0.1%
696683.31
< 0.1%
696636.31
< 0.1%
696630.971
< 0.1%
696613.11
< 0.1%
696606.381
< 0.1%

Interactions

Correlations

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

Sample

First rows

OBJECTIDlinqmap_typelinqmap_subtypepubDatelinqmap_reportDescriptionlinqmap_citylinqmap_streetlinqmap_nearbylinqmap_roadTypelinqmap_reportMoodlinqmap_reportRatinglinqmap_expectedBeginDatelinqmap_expectedEndDatelinqmap_magvarnCommentslinqmap_reliabilityupdate_datexy
016519JAMJAM_STAND_STILL_TRAFFIC2022-05-15 09:31:17NaNNaN443 מערבNaN605NaNNaN272071652608382307197236.32650361.57
116520WEATHERHAZARDHAZARD_ON_SHOULDER_CAR_STOPPED2022-05-15 09:43:09NaNפלמחיםNaNNaN205NaNNaN174061652608382309173578.82649010.73
216521JAMJAM_STAND_STILL_TRAFFIC2022-05-15 09:40:57NaNNaNל-6 דרוםNaN405NaNNaN209071652608382310196444.19679037.74
316522ACCIDENTNaN2022-05-15 09:28:38NaNפתח תקווהNaNNaN2005NaNNaN60051652608382310189858.74668371.12
416523JAMJAM_STAND_STILL_TRAFFIC2022-05-15 09:37:25NaNגבעתייםבן גוריוןNaN205NaNNaN13061652608382310183121.44665120.96
516524JAMJAM_STAND_STILL_TRAFFIC2022-05-15 09:50:03NaNNaN44 צפוןNaN605NaNNaN292051652608382311188724.04648404.31
616525JAMJAM_STAND_STILL_TRAFFIC2022-05-15 09:19:19NaNNaN2 דרוםNaN305NaNNaN198071652608382311188532.73694510.08
716526ROAD_CLOSEDROAD_CLOSED_EVENT2022-04-05 09:56:53NaNרמת גןתלפיותNaN100NaNNaN00101652608382311182329.61665960.52
816527WEATHERHAZARDHAZARD_ON_SHOULDER_CAR_STOPPED2022-05-15 09:50:53NaNNaN6 דרוםNaN305NaNNaN1980101652608382311198699.39683382.25
916528JAMJAM_HEAVY_TRAFFIC2022-05-15 09:21:10NaNNaN2 דרוםNaN305NaNNaN153091652608382312188666.85695586.66

Last rows

OBJECTIDlinqmap_typelinqmap_subtypepubDatelinqmap_reportDescriptionlinqmap_citylinqmap_streetlinqmap_nearbylinqmap_roadTypelinqmap_reportMoodlinqmap_reportRatinglinqmap_expectedBeginDatelinqmap_expectedEndDatelinqmap_magvarnCommentslinqmap_reliabilityupdate_datexy
1827725693ROAD_CLOSEDROAD_CLOSED_EVENT2022-01-04 21:37:08NaNאור יהודהיגאל אלוןNaN200NaNNaN0061653396782617186214.39659530.06
1827825694JAMJAM_HEAVY_TRAFFIC2022-05-24 12:34:15NaNראשון לציוןאליהו איתןNaN105NaNNaN114051653396782618177869.94655568.57
1827925695JAMJAM_STAND_STILL_TRAFFIC2022-05-24 12:39:39NaNגני עםהבניםNaN205NaNNaN244051653396782618190578.65673141.42
1828025696JAMJAM_STAND_STILL_TRAFFIC2022-05-24 12:37:21NaNפתח תקווהרוטשילדNaN205NaNNaN185061653396782618188891.30666391.81
1828125697ROAD_CLOSEDROAD_CLOSED_EVENT2022-05-17 12:38:22NaNתל אביב - יפושתוליםNaN100NaNNaN0081653396782619180794.64661410.20
1828225698ROAD_CLOSEDROAD_CLOSED_EVENT2022-05-15 17:00:03NaNרחובותNaNNaN100NaNNaN00101653396782619178853.06645047.15
1828325699ROAD_CLOSEDROAD_CLOSED_EVENT2022-01-04 21:37:10NaNאור יהודהיגאל אלוןNaN200NaNNaN00101653396782619186260.92659751.11
1828425700WEATHERHAZARDHAZARD_ON_SHOULDER_CAR_STOPPED2022-05-24 12:50:42NaNNaN444 צפוןNaN605NaNNaN0051653396782619194659.70651846.50
1828525701JAMJAM_STAND_STILL_TRAFFIC2022-05-24 12:27:39NaNNaN5504NaN705NaNNaN194051653396782619196156.07678754.28
1828625702JAMJAM_STAND_STILL_TRAFFIC2022-05-24 12:36:25NaNNaN4 דרוםNaN305NaNNaN193061653396782619185775.79667532.36